SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 674481 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 674481 [ RunTime:0.005287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019878,224199,909843,639511,968060,836817,94912,524745,901373,207275,75699,682242,553579,464331,652962,643843,875504,813203,1010550,898248,949208,610892,291025,701989,322810,440613,154432,172102,749527,964406,822971,313432,365397,850682,76176,222587,443699,917339,245601,984662,565729,165519,359765,537614,812644,297439,495595,300556,92243,907620,376895,303399,125713,481338,920194,286139,706930,274142,4035,563881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 674481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 674481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]