SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002928s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403187 LIMIT 1 [ RunTime:0.003019s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403187 [ RunTime:0.004173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875235,163277,965188,759219,613240,186435,627902,903796,984235,95507,292943,246514,824811,845381,826097,490637,121032,449243,31626,217502,470973,27885,691941,917312,293788,760433,841474,269261,648381,124890,210940,791362,1009900,547710,964633,91069,73786,422504,318730,720117,1026686,777059,411150,82768,492703,165263,1046663,499447,389736,860464,952647,550765,254574,212563,704474,845143,625179,962895,957814,265460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000970s ]