SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427914 LIMIT 1 [ RunTime:0.000674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427914 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291271,94333,664919,491630,758300,404359,703883,973969,843446,380628,584420,398572,390302,360123,542681,439275,1016209,356418,610870,969765,342712,805907,605962,111060,991690,1012557,848832,214174,272426,916926,859307,308776,824653,117150,453109,434600,62313,498264,979433,368172,983662,234769,1004742,67561,74802,623404,2244,250103,120350,695537,780642,464626,394949,574100,1020340,145372,91591,22935,858100,299335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000843s ]