SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654813 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654813 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250797,377107,927643,721489,814231,567516,536500,442892,935886,772343,373023,426144,704491,651169,198633,83419,802048,154958,224224,196741,400455,75050,19109,1024532,889449,968122,705088,722763,469037,27860,29549,276223,291189,491859,783447,816499,1025603,276357,736145,133594,873294,723192,667910,14288,286649,831801,939224,314147,604654,792412,669434,460948,590623,1025248,278812,598757,625696,832873,200018,420013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]