SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429811 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429811 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727522,1046351,162228,817522,692153,473109,574600,364098,170187,790023,716717,655940,245335,127828,748156,400976,747669,307814,764926,18577,13094,968344,747442,828026,135661,630792,768718,33844,1033221,1036939,195504,811722,915185,997394,729948,444594,118675,902174,756562,369823,980090,28170,106346,254302,487887,703391,865036,237564,677587,883079,617851,800178,1043068,562892,604627,381276,846483,578441,926140,579660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]