SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420223 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420223 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111257,664350,545304,122112,457384,835999,587277,576119,697356,119652,974750,380817,28072,941869,260851,740890,44053,356960,648551,95524,109321,130457,459456,987570,534811,8863,1030650,231656,398851,173364,891081,367107,462869,775366,112158,927511,922031,228841,323336,428156,69994,790427,801781,208020,143254,535499,83688,136907,124434,297625,118134,1038245,666513,588732,847556,883764,805116,193701,730302,344124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]