SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502928 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502928 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526403,609875,589530,242192,584769,740447,288303,786676,573643,11279,479682,426050,69744,881537,108493,709844,218485,266708,234000,318229,47429,124416,17876,195499,626827,196581,151215,39891,924978,528679,87910,761812,180033,621757,542140,145814,199159,133649,568693,425802,502927,633809,1037089,525614,763443,54153,296705,971528,948106,983185,384569,178738,272239,494829,362158,515905,823391,813032,597707,289427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002519s ]