SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 908329 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 908329 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008010,639954,577174,544660,339437,24907,815990,494348,605841,65455,992583,29525,456325,903291,969260,320510,31648,725629,116497,687441,17809,918144,333136,922486,529583,929563,378768,436415,339224,457555,1024287,180472,508040,19588,822828,648665,708097,585339,428863,979761,17218,377347,506050,132214,22691,651857,251035,997854,915313,589625,821004,79781,397813,682280,300247,210212,59644,127999,693332,315457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 908329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 908329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001329s ]