SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438317 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438317 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701693,183474,67152,629229,922739,577679,22188,711896,1010644,98961,370240,770425,436155,183994,816146,755756,499676,884640,841864,928279,946724,892804,944288,359603,245040,127841,424079,97310,177041,413520,402674,359404,866609,865935,941429,349721,885878,500232,386361,554645,665097,629437,233232,397277,172877,498424,591499,234347,35717,704629,295463,739888,544532,536934,496158,883737,468904,657434,1043196,97884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]