SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003556 LIMIT 1 [ RunTime:0.001238s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003556 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449617,857409,1002628,776967,503963,349334,1009117,883561,1026481,310395,781291,131571,15544,90138,168944,259762,791832,626490,444624,476205,996548,49951,969621,609085,69318,895761,586852,836341,712740,74519,826105,89181,304097,1047196,476279,630205,988080,40670,995321,507321,69338,506746,106833,242569,676199,553194,464275,992230,401790,290324,651718,134340,760399,962228,469223,469933,429889,138632,945348,345590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003556 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003556 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002156s ]