SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402191 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402191 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485939,985400,58920,618981,614090,178628,355954,841972,479548,714716,701483,397971,28080,830286,843917,504065,527995,937513,967855,414367,723185,626891,253377,94263,374910,61966,585994,37258,579141,620574,748900,714558,867919,55771,427721,662361,766616,680475,484952,525913,500839,1005335,665820,225696,752440,966920,337988,26278,124522,905852,504685,984896,185459,721681,23880,595445,737678,802619,834131,985868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]