SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343048 LIMIT 1 [ RunTime:0.003810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343048 [ RunTime:0.003622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353490,190140,27095,264205,584949,986150,884801,574904,411248,510808,511050,469359,83019,461424,774502,414047,211291,777789,978689,23175,176657,27500,903381,392963,415133,876865,11248,54106,332814,204035,525260,240118,653819,165133,710208,716499,12469,898639,480070,506429,171698,517207,603263,791095,474645,906838,619332,1025318,713295,562022,516482,806084,677386,557748,383209,377336,1031215,635059,9750,158612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]