SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105409 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105409 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169248,92088,304339,184342,563270,303719,375231,199423,646901,636784,807057,1038304,419884,457506,281473,225260,173920,809238,364072,42749,859265,96714,282623,1043470,426233,407468,288332,948164,726267,300051,367606,355959,164982,751460,1033012,71546,340354,1016149,775435,1006346,562680,643867,245398,784652,765620,278165,839687,522933,562614,944826,478213,1004197,670510,59329,714123,404037,145993,241035,101391,611132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001272s ]