SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518902 LIMIT 1 [ RunTime:0.000732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518902 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703418,429389,256442,715378,318797,725269,649064,865017,713945,777617,862416,364376,899981,478959,34199,525457,583357,451621,709520,734343,920208,626292,615617,391541,565990,967546,436045,458210,945936,933882,956078,1032111,158158,1019536,116547,870783,633666,413420,595380,833133,219734,566292,349007,893317,353858,56919,304370,975828,1038998,665374,377097,940697,222030,562763,187151,668597,86767,605938,637716,90441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]