SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4443 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4443 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38405,857732,1037886,105839,884656,251131,62919,1010291,580032,645408,393850,812900,283701,901915,120438,472111,152086,98779,135624,630986,746645,815479,844311,335424,239469,962069,597725,577325,278389,946830,513170,982781,754533,589213,980392,981495,577517,100868,815247,553640,236,458230,200870,875529,417634,310430,755880,33979,297486,279801,224564,383034,867179,534631,232586,639243,463545,406227,1001302,319631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]