SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503880 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503880 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694699,868830,411651,327023,479530,182659,245956,739410,646081,970138,41293,656432,692741,988524,42765,930416,80905,694592,729845,1010652,581398,584981,48375,782627,719072,824703,201826,846461,710374,524390,15989,673403,872118,984916,899136,956967,171219,483629,314098,551889,1010147,42105,145040,1040291,634472,679698,215085,52644,569882,145274,398314,352391,303427,732072,186623,4719,750055,961817,776033,97658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]