SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449811 LIMIT 1 [ RunTime:0.001082s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449811 [ RunTime:0.004854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4271,444954,463645,715858,507311,766658,894933,395901,546699,691189,75355,1000801,253626,265943,877826,139342,246233,1004473,856392,299707,126551,982095,590718,972237,505621,474333,290860,563637,57295,219966,738989,491632,632355,181612,1022341,427865,784178,474799,549165,379381,632654,940325,873256,144294,329205,412940,412448,51706,420280,626092,1025011,673148,998536,797624,608898,778756,942417,61800,821064,653771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]