SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412622 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412622 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533747,156080,766888,231072,352331,717816,978083,762093,520071,808923,136141,825902,173379,870195,89471,800543,813091,677831,249749,1041017,78261,379407,358414,980433,1044873,123042,355762,788369,361476,66433,964931,346051,848745,943144,677679,316403,203345,509963,945861,519961,709133,683889,825327,538263,805966,298125,736301,570727,995946,3635,537715,880489,691631,1046652,814650,76542,731168,458678,510976,838340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]