SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042564 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042564 [ RunTime:0.004187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836117,650104,563413,513851,319595,115688,437517,1044412,802663,494347,817134,1045924,634282,625661,43784,412527,636725,1007283,112387,469282,668307,249114,552760,626506,460391,328197,586486,990159,845851,225084,426964,1022575,918456,62043,971983,795946,677571,903679,130083,190411,73886,752233,782176,360679,954527,104530,170725,929966,695215,37,86288,314479,758437,325052,149196,606249,759223,811582,615305,877159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]