SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41829 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41829 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555905,135948,678067,377230,369135,89810,489964,69814,226963,1020821,886421,48071,346506,1019173,670507,809612,854954,1047987,366057,444959,886271,920722,414304,304324,337405,274598,1037810,115423,240271,298375,1024039,821124,1013782,1036117,972237,234853,492413,1012349,988154,663845,532016,487912,657828,451827,529302,1038841,806440,280190,218606,82621,300401,1011579,769420,774554,638126,741383,73688,791513,339009,395189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]