SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108522 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108522 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82036,112014,993120,314933,1001976,758576,717349,404272,588214,976545,318806,766807,1044084,54948,519987,939466,254311,369250,563111,901938,203167,2233,984691,438490,40916,314740,571065,186142,83616,366196,247123,531677,685692,1006960,533939,866863,144404,29102,950046,1004333,640005,551800,333120,862883,550554,105428,442490,987831,185198,688480,519587,207695,452151,192947,161392,586267,815445,889643,276831,363457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]