SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180018 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180018 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48073,945762,402991,633323,276684,564966,343801,898932,444867,819809,264654,342088,641451,82013,500524,488000,866387,783174,117276,683975,482054,40177,578361,736650,612125,533688,472148,5472,918693,429007,1048474,710204,167755,476744,42184,695511,173490,859383,1007778,418650,797956,486970,46093,931036,108262,170620,915384,264424,364838,846210,273448,874882,316690,88720,693398,250708,353621,410160,845133,150691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]