SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034906 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034906 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181559,728507,483614,717164,263348,435069,1014293,18898,44501,972420,214916,928695,50394,224210,547413,708695,850000,931386,735376,742722,819655,22676,577020,1027222,623260,3026,903742,512383,41814,46004,875279,675981,282124,1046126,185258,100346,356318,406820,182126,971202,1023302,442649,497020,259665,751584,1008749,1027536,531473,666115,252328,336303,540421,523787,325497,93052,721274,458565,86393,604564,521765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]