SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971408 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971408 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605840,758614,376810,902370,175598,280769,915179,412158,150511,853980,409560,36238,758718,71860,675275,679214,29095,98458,344814,724220,174305,945677,992326,56923,325675,196125,304475,242479,552123,482223,623765,227605,111932,930211,473551,151780,561524,448960,370291,53600,447274,278310,166599,931159,141905,497017,170878,890347,914523,28270,679503,754960,669598,927268,1047109,133086,700247,631427,1045297,504868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]