SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 716566 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 716566 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577297,855910,461780,362337,593592,206091,277681,761313,1019260,987309,195781,1037909,349722,1009081,975346,225356,1011197,901744,497958,666440,416806,402379,28816,235436,964564,1019719,807232,155624,589406,150186,687689,239898,13741,855030,746018,13995,97168,215156,829668,342860,386168,866435,27232,444568,1015334,33289,692422,562547,859875,721912,454594,794728,507689,204283,288196,365227,138758,670578,891600,422131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 716566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 716566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]