SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 898643 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 898643 [ RunTime:0.002689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721928,157604,453105,603018,58609,429496,31546,264146,699468,545554,1041783,345004,191825,121496,43009,130292,201107,925576,612444,486562,910953,1036142,535207,418268,180441,487834,135325,907973,518428,768240,583236,211429,257911,815035,386006,423080,390366,66383,579222,443752,917087,629857,1041825,530090,18039,438381,9815,76325,317679,362750,178863,829245,322015,533889,595017,926825,454883,312513,361152,364975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 898643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 898643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]