SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245014 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245014 [ RunTime:0.002204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410390,1031794,226987,497726,924167,295434,843147,561076,737478,467067,19271,763551,257377,838266,558455,530496,305301,441745,804053,812963,507933,52808,890132,703903,157845,115786,575481,338757,81844,691334,988711,559851,390729,384956,331418,340056,544369,831335,324318,540410,453220,113654,879464,225670,393456,35813,889635,292267,943428,245373,196448,178273,540962,810482,4947,788313,786729,77705,588304,5484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]