SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42903 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42903 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675052,605354,681199,239766,517676,889286,911625,989483,712585,166937,847822,821738,25345,732147,745920,6756,187001,627887,433521,296941,272995,88036,595221,464709,899757,83978,990718,128230,950625,81592,910032,668703,919501,265035,378649,1017290,894859,145493,988052,510650,1005656,842794,698785,4506,276420,662855,753248,342815,668086,842229,1023539,513317,308391,291541,595868,536913,512882,193344,698439,1036163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]