SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543581 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543581 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118973,249108,744024,227737,983331,641103,136548,690418,927453,296688,754287,620095,542183,320394,444238,653662,626489,329496,876021,399295,502502,858297,741506,447117,696249,755401,94465,538526,167670,660001,264053,375306,490529,418365,308166,477068,623239,969160,45856,464363,643491,422717,877461,587125,942795,353945,890915,938091,893172,1035227,889336,253034,499144,420347,766493,275866,725024,315020,542671,891319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]