SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344906 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344906 [ RunTime:0.002789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042583,699801,205967,70679,933985,485685,702312,192023,543,102685,861668,923665,670542,58510,973779,751543,52654,304482,943711,210289,326814,811417,1027208,450270,102621,115063,946477,559627,509388,911226,671665,713720,186153,703998,967455,666437,96636,32977,666564,787578,190798,210945,704872,437607,744838,517754,655008,316944,203487,360036,650633,181610,408271,90935,135710,936017,40513,914549,355504,248977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]