SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456309 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456309 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341732,715378,560765,857671,869442,507850,382443,848612,701008,614727,433129,230299,124024,573261,571087,932330,321118,511951,270013,908350,911118,821470,944499,846500,64936,117420,406971,81576,991768,26207,915940,660353,949470,389331,550783,387020,153661,598465,912913,577433,579450,154453,473254,526775,151855,240518,442945,801339,226957,370791,338470,433052,272999,461396,876805,611550,918389,829604,572999,146076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]