SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315287 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315287 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231356,250778,500544,173738,796713,449685,345359,584705,186070,693058,961001,846036,856348,765837,778205,137261,1041577,739448,778091,1048306,212328,39181,543527,786416,1009069,338714,893445,1003280,560586,441041,121765,604241,459333,791249,167483,163644,793679,221971,1027134,1030392,500777,153726,886281,914201,657585,981698,755798,317918,797324,1016110,109974,447315,212630,888629,772995,859004,671677,452698,247482,948335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]