SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822343 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822343 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351222,193540,402542,246309,280800,723735,1020071,920882,754167,135649,428380,738820,41543,980858,406160,688556,106924,286389,219167,757036,577622,234307,294574,691942,169974,257608,625928,1025467,307493,499007,738020,339993,364433,59634,1046543,365971,372604,400659,301266,372566,77105,930792,399973,764555,545192,418395,843654,752472,1020890,529126,1019129,677518,818017,621658,860953,1023264,150540,26517,396762,56512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]