SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002081 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002081 [ RunTime:0.001388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446916,803471,556809,408507,136526,916707,710958,866027,279485,772154,322110,762766,686212,305240,375697,581877,892115,795684,958014,399108,12431,314300,946041,623242,79952,642131,801463,1065,305062,104542,318017,893937,422733,474854,248217,746839,836075,614900,190034,609571,104428,527371,138994,636022,202290,804680,621115,266857,937368,971760,106427,374917,451700,867893,559188,298597,506982,637294,184321,1029664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]