SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468961 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468961 [ RunTime:0.003793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343432,720256,1012446,673778,676299,54277,611350,515625,27448,682488,818608,895367,96782,544188,675903,719781,508279,728249,899306,174914,880388,159822,989091,17936,820683,816599,433438,925317,843495,163111,828320,38637,460361,139337,578645,1046091,92932,531846,312186,878707,892307,101421,216413,859784,678315,797877,378619,560400,1005779,359704,691364,613328,328142,288091,319657,849194,403241,79948,1044950,498198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]