SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326584 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326584 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711925,793392,545765,527717,1004770,410884,747834,744182,97391,823803,906131,839022,69486,495828,888288,584952,27868,1007104,1030537,1038447,740174,646867,400980,77167,799868,690981,386210,6999,1009618,871880,464156,173103,27605,1021813,1030806,199980,1032808,433051,716198,451933,248576,829824,139814,527902,211397,150193,435263,126051,478240,188946,298550,990266,550105,333824,160741,906109,94450,867071,292424,784301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]