SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045222 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045222 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352363,32422,902217,896051,331811,690127,437522,199907,808555,976299,160362,484467,382945,327110,2386,96581,393338,289536,580347,847283,204023,245672,295203,405125,525270,161407,411232,360960,1017070,796885,578314,991979,475752,878720,79425,328619,856589,1024087,965432,841516,714797,448749,195061,275705,518478,329868,446127,78469,312696,288955,434964,711973,595353,992023,332488,845409,272348,1434,1011954,51290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]