SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525512 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525512 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111176,961917,34418,491558,812461,1019438,976408,719114,994627,801447,336213,312868,613219,991883,302393,979150,11180,387986,842487,335031,39527,414651,814305,337213,896669,727963,470737,887413,202338,9757,674564,964037,704294,168471,373751,857833,601105,930774,163729,977744,138258,384649,121607,616617,368376,619600,563375,71936,841826,749920,8379,28264,172636,923753,734336,904172,207858,761504,776791,759683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]