SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491423 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491423 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441647,801232,421202,893292,540893,182609,686399,40284,748885,782977,550965,679412,871801,179759,95844,835968,801931,853284,433188,238727,374818,1015595,1023911,935199,289078,24228,1033372,496603,500908,617049,252007,17081,83820,137876,487423,453677,833018,1436,352371,653671,239177,47480,532984,761963,170675,760756,720557,260313,706430,798690,50648,351316,424740,225992,1001967,60266,456229,105129,98295,603513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]