SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10702 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10702 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13110,549881,215871,60472,633727,104392,463680,870011,447006,586384,432558,1047491,814984,637904,752722,398413,670069,487501,87824,901032,922399,667550,185858,114493,665550,1048070,60425,528638,422314,903158,566184,702181,946833,164378,461326,860284,753403,342988,14097,900227,825446,700184,1003050,1027516,714070,524698,846386,305736,692460,148827,16293,173299,165972,267681,640399,940561,720961,518656,29510,534932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]