SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340460 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340460 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016505,1035442,540790,602670,957348,976095,58009,424209,724661,567535,98155,125526,563203,838182,857833,1047245,322196,772198,400540,993203,263017,291916,275957,671100,371751,788989,937278,718632,515416,235562,19213,891256,114631,147642,1028133,166470,779869,352559,455385,825447,494577,748510,458129,282748,208189,1040281,765250,415718,749188,526343,172584,517192,58770,560799,272724,1017399,320768,827101,754450,394046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]