SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452891 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452891 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420791,826738,132182,956400,303865,61893,407205,973652,721483,601363,870103,492799,1000635,119036,278877,231151,566158,714007,631156,704356,48652,981095,162509,715414,869975,101495,94001,16225,229626,899475,621423,496977,514387,962688,204564,147843,734741,654840,969053,46128,790471,107980,248443,497251,977838,58082,573147,917181,587088,364460,206213,572287,215211,947034,193256,499270,482632,691849,114610,554104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]