SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539015 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539015 [ RunTime:0.002956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55921,462537,642108,822245,557926,626438,458565,573835,820194,586484,141083,609240,693393,907284,255930,109016,563220,184076,56225,679387,602155,941984,808457,499914,431023,914065,674989,1024710,840502,631225,412528,534179,884426,73417,477764,97987,120289,1013189,921619,190363,487484,433063,249048,311460,88027,531835,1002461,476004,1013749,41326,28572,818444,895403,174855,335178,206933,251664,502732,37270,104048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]