SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002702s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421734 LIMIT 1 [ RunTime:0.001649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421734 [ RunTime:0.002505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027178,502450,297679,152558,588827,1005001,1048184,96159,809235,806163,397487,494764,572365,749896,214747,386541,754377,506020,84048,893974,1003191,124687,958645,662650,387332,757937,307976,648742,588635,838945,966631,1042251,935716,98781,80660,810995,213382,896810,83520,428858,653595,281843,355051,881562,119375,130850,1025251,467737,913530,596019,647639,1033890,686195,281912,15430,775737,649311,834967,491616,457333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421734 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421734 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001344s ]