SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015226 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015226 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42002,933707,855975,50311,638508,51370,944517,548062,277988,477068,535561,466347,395848,613915,648595,759445,92677,889481,357324,75259,129776,410762,822022,637501,26646,535705,707096,429217,825481,24629,310746,507862,269976,162836,409005,158318,754620,1030656,8761,526379,668990,548263,117520,420667,292879,64364,269351,644169,574795,566537,889241,141389,433217,756334,682004,745821,497577,824381,309507,600795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]