SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802091 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802091 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285811,225080,1009111,680128,371738,322527,943012,113027,160,283756,193565,27242,835764,529330,542053,272543,496637,443269,178862,991687,444818,740775,106267,3963,611178,660622,2933,1021960,128006,605208,450391,491976,1013559,871359,521132,453311,962283,913744,304628,339458,296901,737481,485348,206891,800971,936091,44713,416819,493298,178037,80070,265798,774475,979082,374373,596619,940689,131736,357294,195486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]