SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530072 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530072 [ RunTime:0.004397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566015,105257,687089,718360,757501,432606,910364,445958,913837,878511,707574,1003842,772878,1038973,421512,117797,837616,740702,246247,518893,935045,984490,327152,460423,467917,814587,874815,191687,1022985,239573,823104,23997,347758,352331,710024,926857,493120,893390,530881,897040,411675,22809,551882,638377,584750,907281,176042,334067,401010,53901,349273,728709,707640,33493,572496,338861,519591,437355,117119,1043559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]