SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28112 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28112 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000466,172918,436852,191016,297219,732333,411118,401633,794856,416474,1037607,806171,1035057,237475,799389,883493,189698,842858,220431,104908,76406,165549,585994,334867,998891,485583,720027,356431,307029,798499,471762,108363,883730,192565,664019,465377,247274,459686,12675,407609,99198,28819,136359,510089,417197,26524,249175,253183,386130,526831,796984,976807,782252,737308,235480,523817,549570,259297,337379,399684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]