SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 929240 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 929240 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548944,547349,430595,394259,810674,579618,420899,227028,1025059,682320,118125,601021,963063,141428,179780,379689,112156,1003451,124747,93684,1027048,362190,701207,677002,44263,728496,367216,351482,408989,546403,1041804,460717,192712,992199,750046,709646,1033683,1040597,177088,685416,728205,260764,535051,710279,363507,473734,1005297,778297,310405,140039,880607,508601,854200,615196,554927,856146,127340,42981,853635,611601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 929240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 929240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000950s ]