SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481319 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481319 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313237,851640,269915,423855,641701,332466,707110,744085,408091,543684,559838,692995,437473,105230,1012803,300620,862253,817227,707093,554230,55628,708532,283840,376184,585098,851274,276022,797481,478949,742119,50507,332331,895780,47915,1031704,457529,499559,165849,561965,977154,228779,728628,1019182,790020,911879,885198,301681,603967,344920,609026,991989,985831,788782,360683,462474,844797,985639,527768,476093,976075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]