SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 128010 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 128010 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142620,436306,314103,848042,780628,802782,220288,719556,683343,641136,594005,351407,309591,524424,368016,385467,689198,894321,507887,478942,352797,897597,858874,955442,8061,986213,724658,888013,1030597,165789,8246,167012,281868,412794,161999,113072,425763,460580,889190,13539,714288,413089,278454,991617,1030,634229,183820,272233,522801,1043982,593752,96815,568399,499196,197642,129175,334868,951484,383044,26580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 128010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 128010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]