SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98161 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98161 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717022,314315,548277,50636,772290,418558,168638,106527,853837,75552,111260,212638,735671,534119,28924,944946,1015458,798457,1008619,718063,474705,13763,394382,304483,795809,773094,697152,60814,746791,216916,459320,885246,367842,28454,986884,912936,100560,1031683,677299,959076,594904,103742,936991,610551,26246,114710,1009540,286574,785407,361220,914140,602975,703716,921662,354908,583257,827109,891409,804076,965352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]