SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417215 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417215 [ RunTime:0.002250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121944,428788,589887,292996,83103,507637,949695,716074,1031525,532069,346556,19913,770090,405158,841156,813125,191817,749996,476243,466192,672369,243279,168789,302293,503107,534446,394905,450125,1006584,648422,855791,734123,1029035,41342,801051,164507,254194,291255,972153,47784,630593,287012,281763,247252,369402,200779,53456,300377,143073,710060,991558,686130,160555,50950,469240,873411,698137,970413,189347,920556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002154s ]