SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58191 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58191 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031698,726262,1021682,352372,701464,103812,921835,296817,195676,610580,95125,697460,1012782,491950,837803,398450,349446,130275,766192,207446,281827,526179,1013670,468352,254159,325878,231769,284671,230840,635087,373204,1035141,431815,5233,438643,1009844,487715,712992,740326,665612,933553,1023895,382897,58708,415967,956335,891806,1001553,84536,975357,851629,575920,804766,572465,885431,101248,655939,947487,114425,353376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]