SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111508 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111508 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920366,541033,390466,76060,632089,914528,75476,504296,995540,588199,482000,511730,492555,444203,323928,3827,666755,303988,834213,517093,521989,406397,525610,1045509,126654,695668,12250,354614,847600,934101,210347,467905,341088,1024676,352284,824904,546335,684832,633676,773725,961775,697000,609541,174112,1036440,710461,669344,1035106,903347,921044,248451,417411,782509,523936,719119,61517,172696,149327,98424,53731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]