SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393694 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393694 [ RunTime:0.005194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124199,1034252,1001505,152864,249006,51001,468477,671929,456244,864906,273949,976218,427610,222723,121975,368800,751876,15221,97439,158563,918276,811942,338399,513023,47954,528618,983928,464260,356109,386389,589888,458763,983230,137597,466829,736427,616925,912725,358992,425003,495247,643675,4686,624022,416217,951666,928431,149555,300685,374740,773441,648950,937363,242932,529757,595802,825422,269860,319533,566749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]