SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540463 LIMIT 1 [ RunTime:0.002857s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540463 [ RunTime:0.007118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352806,51417,486190,933345,955237,734347,905276,667002,653712,219593,753654,459390,811199,353386,176186,910914,140128,306502,819584,596828,24332,844045,517619,323939,325805,154017,802564,312225,895820,490540,1047524,960932,149812,1032665,680521,7132,764691,77513,883565,270598,778560,1011655,665723,442161,978666,330003,339667,1016198,856286,131936,937459,316284,189802,1042958,903417,262517,816239,334856,358290,197511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]