SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80419 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80419 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871841,104350,922437,507263,617094,554917,921557,306912,902421,436361,872214,805144,846988,251219,929267,1026304,512453,955255,914019,242707,470551,367773,493014,220493,268980,1014423,944795,681636,937308,725378,107635,938498,407138,980941,165408,33541,907454,853185,1039378,1024804,619187,726301,827256,21211,759187,1008724,211447,864259,699512,576937,475953,506460,98277,341198,173386,194118,329402,245180,589675,160850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000791s ]