SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104651 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104651 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639343,1003511,34020,832109,265799,206461,139085,689121,884360,217828,114789,1012700,35034,274186,447767,621019,536995,638324,359735,244419,445944,112878,389786,520343,81086,231120,1045983,985905,69142,774877,1004145,808217,342496,553704,290079,1004977,929574,952820,667508,823150,513779,79834,116919,968195,329583,211410,964659,437457,1000776,396878,56540,122975,372158,614912,649173,751114,745338,811734,699811,531814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]