SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002806s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414205 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414205 [ RunTime:0.001431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007064,662690,139107,325281,617612,286295,534988,505100,391609,920297,976734,889376,518278,826801,678866,138248,223838,455546,409081,250949,248586,73091,380070,118368,92524,1038096,564102,770493,920840,678962,599390,277949,620491,159002,686756,984186,905933,589153,408944,142128,706511,291342,412467,374695,53806,151677,821610,762129,586722,488853,375451,994553,977871,152877,634608,269363,1013718,344051,329425,627203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]