SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002633s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423450 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423450 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838825,957622,37770,146900,480844,346156,816400,547964,575086,569181,1034205,305772,899277,796039,272205,578921,768338,593215,590524,466612,505274,443189,238927,16237,188477,562910,346794,691323,847055,493039,790053,323155,569872,878147,850146,471807,206727,526247,337045,171351,718940,1035495,1032675,130818,997793,112985,637801,564504,620555,962088,666078,216564,402723,710894,69787,412787,123592,1025722,138637,316432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]