SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541418 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541418 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68274,587939,844688,433501,914407,189586,972563,857720,580933,526587,203658,488487,841429,754761,956450,805638,560946,165197,733815,829792,417926,1000054,973255,679563,578738,87743,466678,472077,769353,565918,1026039,666280,810094,788983,1042239,386191,498255,897990,896460,363433,859763,487008,168862,813409,241354,345579,5944,45618,481384,844742,369704,600326,589228,715943,942508,97969,254900,291672,679585,167908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]