SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289010 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289010 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282996,969864,783106,975700,684187,885727,674700,855425,126411,197921,707731,740782,272211,878215,947483,186333,771481,69795,642825,243007,331205,524555,402804,513533,963479,700138,107602,401604,459171,544893,73751,531068,911065,15249,40282,940366,757322,69729,528149,26137,15679,424124,141086,101148,810824,1004997,822368,40385,574317,690254,839212,563242,257377,642365,161420,678172,1011349,976424,826633,120980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]