SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047988 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047988 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572764,837729,424803,278633,51971,663226,631121,975599,123768,816351,223480,852792,357097,411299,141191,759225,315316,977058,636549,598628,721895,669718,912249,822475,898750,80106,700847,104686,742698,465580,361852,688420,795142,612291,977863,925448,177176,536515,47978,491394,81271,412737,931436,437662,296056,340132,633693,435126,42496,263410,677606,656364,218521,38775,148763,578230,286490,556237,459371,437607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]