SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50382 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50382 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579994,1023743,666421,568722,326506,655375,490663,609744,1023515,1008492,356534,489303,199484,280628,526450,1009846,912,723672,751460,634136,361808,330245,333489,35680,514281,597447,248439,397433,613019,271031,369461,915960,969885,805871,224073,452429,31714,574898,248279,461441,328828,836226,766070,269213,1017077,319279,263253,784955,1036895,930724,30876,842828,535455,592409,782950,471769,191593,727997,774717,479333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]