SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001992s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412324 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412324 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480860,773265,403286,215417,107142,551100,448622,651952,1001512,431490,263351,989807,1020073,901976,677572,848100,770948,732833,417415,140245,137385,397515,7627,52838,910392,225536,142012,564639,550052,1017205,739579,806368,949039,512885,47315,619292,1046677,460479,845748,704825,632388,263206,629731,384962,865273,808741,480844,502596,558270,148480,540271,774234,541648,79880,967139,309225,482327,591705,628342,737665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]