SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511822 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511822 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27121,899542,799756,372832,560631,37034,121941,445021,281354,412222,692734,416636,251765,941617,407625,396432,925802,415289,100481,484320,696490,213458,748787,75959,144571,322860,731513,447381,690384,1037735,818939,21197,553291,850985,386904,282631,947993,465616,117208,792412,733877,132911,680453,1032182,417717,247532,687524,912496,229927,109200,751837,6991,118743,374935,897505,561955,723084,722176,74479,301905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]