SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038641 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038641 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18441,40401,43054,396653,368658,250834,1012542,261632,195188,344494,437464,1034098,496427,943368,34005,914102,401420,534547,276375,737535,263622,435406,658926,434006,558609,851883,611353,967149,1028462,302559,341790,97036,956477,453433,587795,1028227,614004,916553,89493,530819,551969,81644,953158,408135,255296,401440,719841,779534,227298,280744,769975,516752,135895,90762,715756,796820,920609,859799,102007,289796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]