SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450650 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450650 [ RunTime:0.002572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540516,191216,344364,961694,259348,1012097,940163,373226,606669,572578,932546,544711,642673,458885,138404,51028,941130,997992,392263,71078,521900,64497,283368,961817,577481,6767,638463,903466,960151,15737,794335,278886,1001519,757907,700390,691736,772904,457144,552878,135436,423059,786211,412359,230813,121485,97844,718154,521408,825263,900181,243511,96741,639169,153412,988100,126853,1033477,143437,831651,57410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]