SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 185309 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 185309 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421700,857528,999899,390053,982791,678809,948381,566187,983669,461637,146523,977560,313902,120411,213426,104379,424185,791146,5285,443288,740491,970962,421975,113109,924894,83773,345180,524745,617697,282077,269503,163814,541790,399983,561002,914620,143827,502951,452570,202339,36323,361089,198712,777857,591366,813951,594022,490672,360781,159553,1001606,106061,330886,651938,517773,368046,446938,742306,643964,546292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 185309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 185309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002955s ]