SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470067 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470067 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875758,364792,677264,282356,897087,976594,252481,401410,1016913,640326,258568,386579,806857,8295,198320,9036,973724,391670,945279,687225,294053,329938,41052,922388,171473,948245,455656,109515,195539,636595,43923,357909,742768,763851,313382,824874,1001380,461484,442819,459269,237340,255300,162123,211514,1037661,1027254,1029166,922741,561531,937564,288956,608551,968802,333131,421418,754499,790163,770463,1023523,509066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]